package it.gat.dao;

import java.sql.SQLException;
import java.util.List;

import it.gat.model.*;

public interface TicketDAO {
	
	public void insert(Ticket ticket) throws SQLException;
	
	public Ticket retrieveById(int id) throws SQLException;
	
	public List<Ticket> retrieveAll() throws SQLException;
	
	public List<Ticket> retrieveTicketsAperti() throws SQLException;
	
	public List<Ticket> retrieveTicketsAssegnati() throws SQLException;
	
	public void update(Ticket ticket) throws SQLException;
	
	public void delete(int idTicket) throws SQLException;

	public List<Ticket> retrieveByIdCliente(int idCliente)  throws SQLException;
	
	public List<Ticket> retrieveByNomeUtenteTecnico(String nomeUtente)  throws SQLException;

}
